﻿
create table branch_off (branch_id nvarchar(20))

insert branch_off 
values ('VN0010289'),('VN0010344'),('VN0010011'),('VN0010012'),('VN0010006'),('VN0010007'),('VN0010002'),('VN0010003'),('VN0010010'),('VN0010324'),('VN0010325'),('VN0010335'),('VN0010336'),('VN0010005'),('VN0010242'),('VN0010009'),('VN0010001'),('VN0010004'),('VN0010008'),('VN0010260'),('VN0010326'),('VN0010327'),('VN0010245'),('VN0010136')

create table channel_off (channel nvarchar(20))

insert channel_off 
values ('BDO1'),('BDO2'),('BDO3'),('BDO4'),('BDO5'),('MBD1'),('MBD2'),('MBD3'),('MBD4'),('MBD5'),('DSASME')

create table CHUONG_TRINH_SP_off (CHUONG_TRINH_SP nvarchar(20))

insert CHUONG_TRINH_SP_off 
values ('LD-13-SME CLEAN'),('LD-07-SME-BIL'),('LD-766-MINI BIL'),('LD-762-SME-BIL2'),('LD-875-SME-BIL AUTO'),('LD-876-SME-BIL TAI CAP'),('LD-934-SME BIL EWS')
